using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using DuMez.DAL;

public class Sehirler : IDisposable
{
    #region Fields
    private int _SehirId;
    private string _SehirAdi;
    #endregion

    #region Properties
    public int SehirId
    {
        get { return _SehirId; }
        set { _SehirId = value; }
    }


    public string SehirAdi
    {
        get { return _SehirAdi; }
        set { _SehirAdi = value; }
    }
    #endregion

    #region Constructor

    public Sehirler()
    {
       
    }
    #endregion

    #region IDisposable Members
    public void Dispose()
    {

    }
    #endregion

    #region Methods
   

    public static DataTable GetAll()
    {
        return SqlUtility.ExecuteDataTable("SELECT * FROM  Sehirler");
    }

    

    #endregion
}
